Pandas Profiling Report

Dataset statistics

Number of variables	14
Number of observations	534425
Missing cells	37977
Missing cells (%)	0.5%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	57.1 MiB
Average record size in memory	112.0 B

Variable types

Numeric	10
Categorical	4

Warnings

`Exit_Reason` has constant value "AgentAnswered"	Constant
`Call_Start` has a high cardinality: 521961 distinct values	High cardinality
`Party_Name` has a high cardinality: 147 distinct values	High cardinality
`QueuedTime` is highly correlated with `WaitTime` and 1 other fields	High correlation
`RingTime` is highly correlated with `WaitTime vs QueuedTime`	High correlation
`WaitTime` is highly correlated with `QueuedTime` and 1 other fields	High correlation
`Queue + Ring` is highly correlated with `QueuedTime` and 1 other fields	High correlation
`WaitTime vs QueuedTime` is highly correlated with `RingTime`	High correlation
`Exit_Reason` is highly correlated with `channel`	High correlation
`channel` is highly correlated with `Exit_Reason`	High correlation
`AgentTime` has 36472 (6.8%) missing values	Missing
`Call_Start` is uniformly distributed	Uniform
`df_index` has unique values	Unique
`QueuedTime` has 32124 (6.0%) zeros	Zeros
`TalkTime` has 7451 (1.4%) zeros	Zeros
`HoldTime` has 439575 (82.3%) zeros	Zeros
`WrapTime` has 24445 (4.6%) zeros	Zeros

Reproduction

Analysis started	2021-02-27 23:03:23.394319
Analysis finished	2021-02-27 23:04:11.820385
Duration	48.43 seconds
Software version	pandas-profiling v2.11.0
Download configuration	config.yaml

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct	534425
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	314456.1161
Minimum	13
Maximum	613887
Zeros	0
Zeros (%)	0.0%
Memory size	4.1 MiB

Quantile statistics

Minimum	13
5-th percentile	30486.2
Q1	166542
median	319137
Q3	467008
95-th percentile	584959.8
Maximum	613887
Range	613874
Interquartile range (IQR)	300466

Descriptive statistics

Standard deviation	177027.7056
Coefficient of variation (CV)	0.5629647399
Kurtosis	-1.168492094
Mean	314456.1161
Median Absolute Deviation (MAD)	150031
Skewness	-0.0733312154
Sum	1.680532098 × 10¹¹
Variance	3.133880855 × 10¹⁰
Monotocity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4098	1	< 0.1%
320457	1	< 0.1%
302022	1	< 0.1%
295877	1	< 0.1%
297924	1	< 0.1%
308163	1	< 0.1%
310210	1	< 0.1%
304065	1	< 0.1%
306112	1	< 0.1%
480191	1	< 0.1%
Other values (534415)	534415	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
13	1	< 0.1%
14	1	< 0.1%
16	1	< 0.1%
18	1	< 0.1%
19	1	< 0.1%

Value	Count	Frequency (%)
613887	1	< 0.1%
613886	1	< 0.1%
613884	1	< 0.1%
613883	1	< 0.1%
613882	1	< 0.1%

Call_Start
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	521961
Distinct (%)	97.7%
Missing	0
Missing (%)	0.0%
Memory size	4.1 MiB

2020-08-03 11:15:51.000002	5
2020-09-15 09:18:49.999999	4
2020-07-07 11:11:22.999998	4
2020-08-14 13:48:41.999999	4
2020-10-07 11:17:35.000002	4
Other values (521956)	534404

Length

Max length	26
Median length	26
Mean length	26
Min length	26

Characters and Unicode

Total characters	13895050
Distinct characters	14
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	509708 ?
Unique (%)	95.4%

Sample

1st row	2020-01-02 08:00:21.000001
2nd row	2020-01-02 08:00:56.000001
3rd row	2020-01-02 08:02:52.000002
4th row	2020-01-02 08:03:16.000004
5th row	2020-01-02 08:03:31.000003

Value	Count	Frequency (%)
2020-08-03 11:15:51.000002	5	< 0.1%
2020-09-15 09:18:49.999999	4	< 0.1%
2020-07-07 11:11:22.999998	4	< 0.1%
2020-08-14 13:48:41.999999	4	< 0.1%
2020-10-07 11:17:35.000002	4	< 0.1%
2020-09-09 15:20:19.000000	3	< 0.1%
2020-06-04 13:20:24.999999	3	< 0.1%
2020-06-08 18:35:56.000000	3	< 0.1%
2020-03-02 15:30:53.000004	3	< 0.1%
2020-06-30 12:15:03.000001	3	< 0.1%
Other values (521951)	534389	> 99.9%

Histogram of lengths of the category

Value	Count	Frequency (%)
2020-06-01	3086	0.3%
2020-08-03	3043	0.3%
2020-06-15	3022	0.3%
2020-09-08	3001	0.3%
2020-06-22	2996	0.3%
2020-06-29	2984	0.3%
2020-08-24	2971	0.3%
2020-08-17	2961	0.3%
2020-09-14	2960	0.3%
2020-07-27	2960	0.3%
Other values (51474)	1038866	97.2%

Most occurring characters

Value	Count	Frequency (%)
0	3777023	27.2%
2	1765585	12.7%
9	1422997	10.2%
1	1326957	9.5%
-	1068850	7.7%
:	1068850	7.7%
	534425	3.8%
.	534425	3.8%
3	518955	3.7%
4	485556	3.5%
Other values (4)	1391427	10.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10688500	76.9%
Other Punctuation	1603275	11.5%
Dash Punctuation	1068850	7.7%
Space Separator	534425	3.8%

Most frequent character per category

Value	Count	Frequency (%)
0	3777023	35.3%
2	1765585	16.5%
9	1422997	13.3%
1	1326957	12.4%
3	518955	4.9%
4	485556	4.5%
5	444158	4.2%
8	329692	3.1%
7	317477	3.0%
6	300100	2.8%

Value	Count	Frequency (%)
:	1068850	66.7%
.	534425	33.3%

Value	Count	Frequency (%)
-	1068850	100.0%

Value	Count	Frequency (%)
	534425	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	13895050	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	3777023	27.2%
2	1765585	12.7%
9	1422997	10.2%
1	1326957	9.5%
-	1068850	7.7%
:	1068850	7.7%
	534425	3.8%
.	534425	3.8%
3	518955	3.7%
4	485556	3.5%
Other values (4)	1391427	10.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	13895050	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	3777023	27.2%
2	1765585	12.7%
9	1422997	10.2%
1	1326957	9.5%
-	1068850	7.7%
:	1068850	7.7%
	534425	3.8%
.	534425	3.8%
3	518955	3.7%
4	485556	3.5%
Other values (4)	1391427	10.0%

Exit_Reason
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.1 MiB

AgentAnswered	534425

Length

Max length	13
Median length	13
Mean length	13
Min length	13

Characters and Unicode

Total characters	6947525
Distinct characters	9
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	AgentAnswered
2nd row	AgentAnswered
3rd row	AgentAnswered
4th row	AgentAnswered
5th row	AgentAnswered

Value	Count	Frequency (%)
AgentAnswered	534425	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
agentanswered	534425	100.0%

Most occurring characters

Value	Count	Frequency (%)
e	1603275	23.1%
A	1068850	15.4%
n	1068850	15.4%
g	534425	7.7%
t	534425	7.7%
s	534425	7.7%
w	534425	7.7%
r	534425	7.7%
d	534425	7.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5878675	84.6%
Uppercase Letter	1068850	15.4%

Most frequent character per category

Value	Count	Frequency (%)
e	1603275	27.3%
n	1068850	18.2%
g	534425	9.1%
t	534425	9.1%
s	534425	9.1%
w	534425	9.1%
r	534425	9.1%
d	534425	9.1%

Value	Count	Frequency (%)
A	1068850	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6947525	100.0%

Most frequent character per script

Value	Count	Frequency (%)
e	1603275	23.1%
A	1068850	15.4%
n	1068850	15.4%
g	534425	7.7%
t	534425	7.7%
s	534425	7.7%
w	534425	7.7%
r	534425	7.7%
d	534425	7.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6947525	100.0%

Most frequent character per block

Value	Count	Frequency (%)
e	1603275	23.1%
A	1068850	15.4%
n	1068850	15.4%
g	534425	7.7%
t	534425	7.7%
s	534425	7.7%
w	534425	7.7%
r	534425	7.7%
d	534425	7.7%

Party_Name
Categorical

HIGH CARDINALITY

Distinct	147
Distinct (%)	< 0.1%
Missing	16
Missing (%)	< 0.1%
Memory size	4.1 MiB

Alex Dillon	16188
Daniel Schirmer	13479
Dave Lee Wincek	12990
Timmy Moran	12555
John Gene Vura	12522
Other values (142)	466675

Length

Max length	17
Median length	16
Mean length	15.37343495
Min length	8

Characters and Unicode

Total characters	8215702
Distinct characters	51
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Kyle Younglas
2nd row	Luis Torres
3rd row	Daniel Schirmer
4th row	Mike Bilfield
5th row	Chris Smucny

Value	Count	Frequency (%)
Alex Dillon	16188	3.0%
Daniel Schirmer	13479	2.5%
Dave Lee Wincek	12990	2.4%
Timmy Moran	12555	2.3%
John Gene Vura	12522	2.3%
Alex Baltas	12410	2.3%
Butch Herten	11747	2.2%
Mike Pascaru	11567	2.2%
Alex Hord	10944	2.0%
Dustin Pollock	10937	2.0%
Other values (137)	409070	76.5%

Histogram of lengths of the category

Value	Count	Frequency (%)
alex	56548	5.2%
mike	43662	4.0%
john	25028	2.3%
dan	21513	2.0%
matt	21444	2.0%
dillon	19628	1.8%
joe	18294	1.7%
connor	17387	1.6%
daniel	15936	1.5%
schirmer	15935	1.5%
Other values (146)	838955	76.7%

Most occurring characters

Value	Count	Frequency (%)
	2111031	25.7%
e	687609	8.4%
a	551805	6.7%
n	492022	6.0%
r	425517	5.2%
l	384336	4.7%
o	353388	4.3%
i	351440	4.3%
t	244085	3.0%
h	182184	2.2%
Other values (41)	2432285	29.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4990384	60.7%
Space Separator	2111031	25.7%
Uppercase Letter	1113889	13.6%
Other Punctuation	398	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
e	687609	13.8%
a	551805	11.1%
n	492022	9.9%
r	425517	8.5%
l	384336	7.7%
o	353388	7.1%
i	351440	7.0%
t	244085	4.9%
h	182184	3.7%
c	180670	3.6%
Other values (15)	1137328	22.8%

Value	Count	Frequency (%)
M	151290	13.6%
S	100705	9.0%
D	100223	9.0%
B	95895	8.6%
A	91506	8.2%
C	88815	8.0%
J	76192	6.8%
T	62611	5.6%
K	61756	5.5%
L	39118	3.5%
Other values (14)	245778	22.1%

Value	Count	Frequency (%)
	2111031	100.0%

Value	Count	Frequency (%)
*	398	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6104273	74.3%
Common	2111429	25.7%

Most frequent character per script

Value	Count	Frequency (%)
e	687609	11.3%
a	551805	9.0%
n	492022	8.1%
r	425517	7.0%
l	384336	6.3%
o	353388	5.8%
i	351440	5.8%
t	244085	4.0%
h	182184	3.0%
c	180670	3.0%
Other values (39)	2251217	36.9%

Value	Count	Frequency (%)
	2111031	> 99.9%
*	398	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8215702	100.0%

Most frequent character per block

Value	Count	Frequency (%)
	2111031	25.7%
e	687609	8.4%
a	551805	6.7%
n	492022	6.0%
r	425517	5.2%
l	384336	4.7%
o	353388	4.3%
i	351440	4.3%
t	244085	3.0%
h	182184	2.2%
Other values (41)	2432285	29.6%

channel
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.1 MiB

SEO	390552
PPC	143873

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	1603275
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SEO
2nd row	SEO
3rd row	SEO
4th row	SEO
5th row	SEO

Value	Count	Frequency (%)
SEO	390552	73.1%
PPC	143873	26.9%

Histogram of lengths of the category

Value	Count	Frequency (%)
seo	390552	73.1%
ppc	143873	26.9%

Most occurring characters

Value	Count	Frequency (%)
S	390552	24.4%
E	390552	24.4%
O	390552	24.4%
P	287746	17.9%
C	143873	9.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1603275	100.0%

Most frequent character per category

Value	Count	Frequency (%)
S	390552	24.4%
E	390552	24.4%
O	390552	24.4%
P	287746	17.9%
C	143873	9.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1603275	100.0%

Most frequent character per script

Value	Count	Frequency (%)
S	390552	24.4%
E	390552	24.4%
O	390552	24.4%
P	287746	17.9%
C	143873	9.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1603275	100.0%

Most frequent character per block

Value	Count	Frequency (%)
S	390552	24.4%
E	390552	24.4%
O	390552	24.4%
P	287746	17.9%
C	143873	9.0%

QueuedTime
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	150
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	12.40043224
Minimum	0
Maximum	149
Zeros	32124
Zeros (%)	6.0%
Memory size	4.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	3
median	4
Q3	11
95-th percentile	61
Maximum	149
Range	149
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	21.76125573
Coefficient of variation (CV)	1.754878806
Kurtosis	11.2277466
Mean	12.40043224
Median Absolute Deviation (MAD)	2
Skewness	3.220036816
Sum	6627101
Variance	473.5522508
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4	119064	22.3%
3	71771	13.4%
2	54098	10.1%
5	35068	6.6%
1	33639	6.3%
0	32124	6.0%
6	11947	2.2%
7	10704	2.0%
9	10685	2.0%
8	10254	1.9%
Other values (140)	145071	27.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	32124	6.0%
1	33639	6.3%
2	54098	10.1%
3	71771	13.4%
4	119064	22.3%

Value	Count	Frequency (%)
149	6	< 0.1%
148	19	< 0.1%
147	41	< 0.1%
146	66	< 0.1%
145	99	< 0.1%

RingTime
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	30
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	8.091103522
Minimum	0
Maximum	29
Zeros	1699
Zeros (%)	0.3%
Memory size	4.1 MiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	5
median	7
Q3	11
95-th percentile	16
Maximum	29
Range	29
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	4.257729251
Coefficient of variation (CV)	0.5262235539
Kurtosis	0.4774156763
Mean	8.091103522
Median Absolute Deviation (MAD)	3
Skewness	0.8115948365
Sum	4324088
Variance	18.12825837
Monotocity	Not monotonic

Histogram with fixed size bins (bins=30)

Value	Count	Frequency (%)
6	56145	10.5%
5	53854	10.1%
7	51033	9.5%
8	49051	9.2%
4	48666	9.1%
9	43184	8.1%
10	36164	6.8%
3	33311	6.2%
11	29370	5.5%
12	23453	4.4%
Other values (20)	110194	20.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1699	0.3%
1	7082	1.3%
2	20237	3.8%
3	33311	6.2%
4	48666	9.1%

Value	Count	Frequency (%)
29	2	< 0.1%
28	1	< 0.1%
27	3	< 0.1%
26	92	< 0.1%
25	140	< 0.1%

TalkTime
Real number (ℝ_≥0)

ZEROS

Distinct	927
Distinct (%)	0.2%
Missing	1489
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%

Mean	182.7073251
Minimum	0
Maximum	926
Zeros	7451
Zeros (%)	1.4%
Memory size	4.1 MiB

Quantile statistics

Minimum	0
5-th percentile	12
Q1	49
median	135
Q3	249
95-th percentile	563
Maximum	926
Range	926
Interquartile range (IQR)	200

Descriptive statistics

Standard deviation	174.9070802
Coefficient of variation (CV)	0.9573074319
Kurtosis	2.362593766
Mean	182.7073251
Median Absolute Deviation (MAD)	94
Skewness	1.550173873
Sum	97371311
Variance	30592.48669
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7451	1.4%
20	4123	0.8%
19	3996	0.7%
18	3994	0.7%
21	3977	0.7%
22	3857	0.7%
17	3838	0.7%
23	3726	0.7%
24	3689	0.7%
16	3668	0.7%
Other values (917)	490617	91.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	7451	1.4%
1	1760	0.3%
2	1959	0.4%
3	1807	0.3%
4	1524	0.3%

Value	Count	Frequency (%)
926	23	< 0.1%
925	39	< 0.1%
924	36	< 0.1%
923	15	< 0.1%
922	31	< 0.1%

HoldTime
Real number (ℝ_≥0)

ZEROS

Distinct	163
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4.545215886
Minimum	0
Maximum	162
Zeros	439575
Zeros (%)	82.3%
Memory size	4.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	29
Maximum	162
Range	162
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	18.76823334
Coefficient of variation (CV)	4.129228139
Kurtosis	28.8240296
Mean	4.545215886
Median Absolute Deviation (MAD)	0
Skewness	5.199652205
Sum	2429077
Variance	352.2465825
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	439575	82.3%
1	21134	4.0%
2	10348	1.9%
3	8096	1.5%
4	5520	1.0%
5	4146	0.8%
6	3416	0.6%
7	2629	0.5%
8	2029	0.4%
9	1382	0.3%
Other values (153)	36150	6.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	439575	82.3%
1	21134	4.0%
2	10348	1.9%
3	8096	1.5%
4	5520	1.0%

Value	Count	Frequency (%)
162	64	< 0.1%
161	70	< 0.1%
160	74	< 0.1%
159	77	< 0.1%
158	79	< 0.1%

WrapTime
Real number (ℝ_≥0)

ZEROS

Distinct	1035
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	131.5061926
Minimum	0
Maximum	1034
Zeros	24445
Zeros (%)	4.6%
Memory size	4.1 MiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	14
median	77
Q3	185
95-th percentile	463
Maximum	1034
Range	1034
Interquartile range (IQR)	171

Descriptive statistics

Standard deviation	163.1594447
Coefficient of variation (CV)	1.240697806
Kurtosis	5.94289689
Mean	131.5061926
Median Absolute Deviation (MAD)	69
Skewness	2.201907425
Sum	70280197
Variance	26621.00438
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	24445	4.6%
4	14514	2.7%
5	13530	2.5%
3	12987	2.4%
6	11584	2.2%
7	9686	1.8%
8	8553	1.6%
9	7310	1.4%
10	6568	1.2%
11	5819	1.1%
Other values (1025)	419429	78.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	24445	4.6%
1	1943	0.4%
2	5494	1.0%
3	12987	2.4%
4	14514	2.7%

Value	Count	Frequency (%)
1034	11	< 0.1%
1033	10	< 0.1%
1032	14	< 0.1%
1031	11	< 0.1%
1030	13	< 0.1%

WaitTime
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	151
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	20.49153576
Minimum	0
Maximum	150
Zeros	1277
Zeros (%)	0.2%
Memory size	4.1 MiB

Quantile statistics

Minimum	0
5-th percentile	6
Q1	10
median	13
Q3	21
95-th percentile	66
Maximum	150
Range	150
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	21.29351322
Coefficient of variation (CV)	1.039137011
Kurtosis	10.73462864
Mean	20.49153576
Median Absolute Deviation (MAD)	4
Skewness	3.080602565
Sum	10951189
Variance	453.4137052
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10	42129	7.9%
9	39632	7.4%
12	37045	6.9%
11	36215	6.8%
8	35294	6.6%
14	30443	5.7%
13	28111	5.3%
7	25654	4.8%
16	22494	4.2%
15	20153	3.8%
Other values (141)	217255	40.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1277	0.2%
1	116	< 0.1%
2	266	< 0.1%
3	523	0.1%
4	4070	0.8%

Value	Count	Frequency (%)
150	124	< 0.1%
149	133	< 0.1%
148	138	< 0.1%
147	140	< 0.1%
146	123	< 0.1%

Queue + Ring
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	151
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	20.49153576
Minimum	0
Maximum	150
Zeros	1277
Zeros (%)	0.2%
Memory size	4.1 MiB

Quantile statistics

Minimum	0
5-th percentile	6
Q1	10
median	13
Q3	21
95-th percentile	66
Maximum	150
Range	150
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	21.29351322
Coefficient of variation (CV)	1.039137011
Kurtosis	10.73462864
Mean	20.49153576
Median Absolute Deviation (MAD)	4
Skewness	3.080602565
Sum	10951189
Variance	453.4137052
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10	42129	7.9%
9	39632	7.4%
12	37045	6.9%
11	36215	6.8%
8	35294	6.6%
14	30443	5.7%
13	28111	5.3%
7	25654	4.8%
16	22494	4.2%
15	20153	3.8%
Other values (141)	217255	40.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1277	0.2%
1	116	< 0.1%
2	266	< 0.1%
3	523	0.1%
4	4070	0.8%

Value	Count	Frequency (%)
150	124	< 0.1%
149	133	< 0.1%
148	138	< 0.1%
147	140	< 0.1%
146	123	< 0.1%

WaitTime vs QueuedTime
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	30
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	8.091103522
Minimum	0
Maximum	29
Zeros	1699
Zeros (%)	0.3%
Memory size	4.1 MiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	5
median	7
Q3	11
95-th percentile	16
Maximum	29
Range	29
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	4.257729251
Coefficient of variation (CV)	0.5262235539
Kurtosis	0.4774156763
Mean	8.091103522
Median Absolute Deviation (MAD)	3
Skewness	0.8115948365
Sum	4324088
Variance	18.12825837
Monotocity	Not monotonic

Histogram with fixed size bins (bins=30)

Value	Count	Frequency (%)
6	56145	10.5%
5	53854	10.1%
7	51033	9.5%
8	49051	9.2%
4	48666	9.1%
9	43184	8.1%
10	36164	6.8%
3	33311	6.2%
11	29370	5.5%
12	23453	4.4%
Other values (20)	110194	20.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1699	0.3%
1	7082	1.3%
2	20237	3.8%
3	33311	6.2%
4	48666	9.1%

Value	Count	Frequency (%)
29	2	< 0.1%
28	1	< 0.1%
27	3	< 0.1%
26	92	< 0.1%
25	140	< 0.1%

AgentTime
Real number (ℝ_≥0)

MISSING

Distinct	1782
Distinct (%)	0.4%
Missing	36472
Missing (%)	6.8%
Infinite	0
Infinite (%)	0.0%

Mean	321.1318056
Minimum	1
Maximum	2037
Zeros	0
Zeros (%)	0.0%
Memory size	4.1 MiB

Quantile statistics

Minimum	1
5-th percentile	29
Q1	121
median	253
Q3	443
95-th percentile	873
Maximum	2037
Range	2036
Interquartile range (IQR)	322

Descriptive statistics

Standard deviation	267.1778363
Coefficient of variation (CV)	0.8319880859
Kurtosis	2.033491387
Mean	321.1318056
Median Absolute Deviation (MAD)	152
Skewness	1.366200854
Sum	159908546
Variance	71383.9962
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
29	1587	0.3%
28	1571	0.3%
27	1560	0.3%
33	1537	0.3%
30	1532	0.3%
34	1527	0.3%
25	1525	0.3%
32	1522	0.3%
31	1512	0.3%
26	1500	0.3%
Other values (1772)	482580	90.3%
(Missing)	36472	6.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	20	< 0.1%
2	93	< 0.1%
3	256	< 0.1%
4	303	0.1%
5	370	0.1%

Value	Count	Frequency (%)
2037	1	< 0.1%
2031	1	< 0.1%
1954	1	< 0.1%
1938	1	< 0.1%
1934	1	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	df_index	Call_Start	Exit_Reason	Party_Name	channel	QueuedTime	RingTime	TalkTime	HoldTime	WrapTime	WaitTime	Queue + Ring	WaitTime vs QueuedTime	AgentTime
0	13	2020-01-02 08:00:21.000001	AgentAnswered	Kyle Younglas	SEO	0	9	184.0	0.0	318.0	9	9	9	502.0
1	14	2020-01-02 08:00:56.000001	AgentAnswered	Luis Torres	SEO	0	5	454.0	0.0	15.0	5	5	5	469.0
2	16	2020-01-02 08:02:52.000002	AgentAnswered	Daniel Schirmer	SEO	1	11	411.0	0.0	95.0	12	12	11	506.0
3	18	2020-01-02 08:03:16.000004	AgentAnswered	Mike Bilfield	SEO	0	6	182.0	89.0	8.0	6	6	6	279.0
4	19	2020-01-02 08:03:31.000003	AgentAnswered	Chris Smucny	SEO	1	5	428.0	0.0	35.0	6	6	5	463.0
5	20	2020-01-02 08:03:46.000002	AgentAnswered	Ian Flanagan	SEO	0	8	27.0	3.0	15.0	8	8	8	45.0
6	21	2020-01-02 08:04:21.000003	AgentAnswered	Kenneth Combes	PPC	1	9	522.0	44.0	92.0	10	10	9	658.0
7	22	2020-01-02 08:05:00.000004	AgentAnswered	Mac Blank	SEO	1	3	56.0	2.0	10.0	4	4	3	68.0
8	23	2020-01-02 08:05:38.000003	AgentAnswered	Alex Shroyer	SEO	1	15	14.0	2.0	22.0	16	16	15	38.0
9	24	2020-01-02 08:07:53.000003	AgentAnswered	Michael DiZonno	PPC	0	8	100.0	0.0	5.0	8	8	8	105.0

Last rows

	df_index	Call_Start	Exit_Reason	Party_Name	channel	QueuedTime	RingTime	TalkTime	WrapTime	WaitTime	Queue + Ring	WaitTime vs QueuedTime	AgentTime
534415	613877	2021-02-21 12:05:26.999998	AgentAnswered	Johnathan Jordan	SEO	12	12	132.0	0.0	24	24	12	132.0
534416	613878	2021-02-21 12:07:37.000004	AgentAnswered	Matthew Duff	SEO	11	11	210.0	0.0	22	22	11	210.0
534417	613879	2021-02-21 12:08:27.000004	AgentAnswered	Junior Fetchet	SEO	8	8	133.0	2.0	16	16	8	135.0
534418	613880	2021-02-21 12:13:19.000001	AgentAnswered	Matt Tashjian	SEO	15	15	68.0	42.0	30	30	15	110.0
534419	613881	2021-02-21 12:13:54.000002	AgentAnswered	Matthew Duff	SEO	18	6	92.0	2.0	24	24	6	94.0
534420	613882	2021-02-21 12:14:41.999997	AgentAnswered	Lauren Basch	SEO	17	5	40.0	0.0	22	22	5	40.0
534421	613883	2021-02-21 12:17:38.999996	AgentAnswered	Matt Tashjian	SEO	14	14	121.0	2.0	28	28	14	123.0
534422	613884	2021-02-21 12:18:55.000003	AgentAnswered	Meredith Chesney	SEO	4	4	289.0	1.0	8	8	4	290.0
534423	613886	2021-02-21 12:22:32.999998	AgentAnswered	Matt Tashjian	SEO	17	17	55.0	12.0	34	34	17	67.0
534424	613887	2021-02-21 12:24:08.999997	AgentAnswered	Junior Fetchet	SEO	7	7	201.0	42.0	14	14	7	243.0

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows